R Markdown

Hillary Chen (), Emma Hong (), Julia Kharchenko () , Truc Quynh Nguyen (TQ) () ( Write Intro )

Aggregate Table

# Age Group Covid Deaths by Age Percent Covid Deaths by Age Race Group Covid Deaths by Race Percent Covid Deaths by Race
1 0-17 years NA 0.0137602 Non-Hispanic White 2789044 0.7844225
2 18-29 years 26656 0.0370799 Non-Hispanic Black 599284 0.1710880
3 30-39 years 76256 0.0711354 Non-Hispanic American Indian or Alaska Native 46388 0.0827805
4 40-49 years 178940 0.1127300 Non-Hispanic Asian 133340 0.0404209
5 50-64 years 781492 0.1224238 Non-Hispanic Native Hawaiian or Other Pacific Islander 8900 0.0259211
6 65-74 years 969900 0.1246472 Hispanic 664864 0.1340704
7 75-84 years 1106608 0.1190618 NA NA NA
8 85 years and over 1124884 0.1036245 NA NA NA

Chart 1: Race and Age


We included a stacked bar chart detailing the racial background of those who died from COVID-19 per age group to identify the intersectionality between many marginalized groups when it comes to COVID-19 related deaths (e.g. how Hispanic milennials compare to the Black elderly population). By creating this chart, we can see that the older a person is, the more likely they are to die from COVID-19, and that the proportion of those dying from COVID-19 who are Non-Hispanic White are larger than other groups, likely because they make up a larger population as a whole. However, Hispanic and Non-Hispanic Black individuals tend to die from COVID-19 in larger proportions at slightly younger ages e.g. from 50-64 years, which is an interesting feature to look into and analyze further.

Chart 2: Race

We made a pie chart in order to see how different races has been affected by COVID-19. By the results of this visual, we were able to find out that Non-Hispanic White group made up 84.7% of this pie chart. This means that they were the most affected by COVID-19 versus other races. By making a pie chart, we were visually able to see the data as a fractional part of a whole which can be a straight forward and effect communication tool for even an uninformed reader.

Chart 3: Age


We included a standard bar chart to examine the age groups of individuals who died from COVID-19. In looking at this chart, we can understand that older age groups, specifically between 74-85 years old and 85 years or older, were much more susceptible to COVID-19, and likewise more likely to die from the virus. In opposition, younger age groups were less impacted by the virus, with adolescents and children in particular having almost no deaths in comparison to the older age groups.